MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 2650

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Artist Nationality

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
223517 65.631.2(1–121) 0 0 351097 Drawings and Prints 11 Book 97 Oeuvres Complete de Béranger           Publisher|Illustrator|Author 2650 Published by|Written by Fournier & Perrotin|J. J. Grandville|Pierre Jean de Béranger French|French, Nancy 1803–1847 Vanves|French, Paris 1780–1857 Paris   Fournier & Perrotin|Grandville, J. J.|Béranger, Pierre Jean de 25512 French|French|French 103 1803 |1780 1847 |1857 1836 1836 1836 wood engraving and lithograph 35245   Gift of Lincoln Kirstein, 1965                       Books 442   Metropolitan Museum of Art, New York, NY 1
223766 57.587.10 0 0 351352 Drawings and Prints 11 Book 97 The Elements of Drawing           Publisher|Illustrator|Author 2650   Richard Phillips|Thomas Lord Busby|George Hamilton London|British, active 1804–37|British, active 1812   Phillips, Richard|Busby, Thomas Lord|Hamilton, George 25716 British|British 9 1750 |1804 |1780 1850 |1837 |1900 1812 1812 1812 Illustrations: aquatint, stipple etching, engraving, etching and hand-coloring 35284 7 3/4 x 5 1/4 in. (19.7 x 13.3 cm) Administrative Purchase Fund, 1957                       Books 442   Metropolitan Museum of Art, New York, NY 1
228463 35.65.3 0 0 356098 Drawings and Prints 11 Book 97 Umrisse zu Schiller's Pegasus im Joche nebst Andeutungen zu den Rissen           Publisher|Illustrator|Author 2650   J. G. Cotta|Moritz Retzsch|Johann Christoph Friedrich von Schiller German, Dresden 1779–1857 Hoflössnitz bei Dresden|German, 1779–1857 , Stuttgart Cotta, J. G. (Buchhandlung)|Retzsch, Moritz|Schiller, Johann Christoph Friedrich von 29041 German|German|German 80 1779 |1779 1857 |1857 1833 1833 1833 Etchings 28944 Overall: 8 3/4 x 12 x 3/16 in. (22.3 x 30.5 x 0.5 cm) Harris Brisbane Dick Fund, 1935   Stuttgart/ Tübingen 1380                   Books 442   Metropolitan Museum of Art, New York, NY 1
229667 24.90.1869 0 0 357331 Drawings and Prints 11 Book 97 The Institution of the Society of the Cincinnati           Publisher|Illustrator|Author 2650   Manning & Loring|George Graham|Society of the Cincinnati Boston, Massachusetts|American, late 18th–early 19th century|founded 1783   Manning & Loring|Graham, George|Society of the Cincinnati 29914 American|American|American 101 1780 |1750 |1783 1900 |1850 |9999 1801 1801 1801 Illustrations: engraving 28942 8 1/4 x 5 5/16 in. (21 x 13.5 cm) Bequest of Charles Allen Munn, 1924                       Books 442   Metropolitan Museum of Art, New York, NY 1
229685 36.2.7 0 0 357353 Drawings and Prints 11 Book 97 Les Sonnets du Docteur           Publisher|Illustrator|Author 2650 Published by|Written by Éditions du Raisin|Jean-Émile Laboureur|Georges Camuset French, Nantes 1877–1943 Penestin|French, 20th century , Dijon Raisin, Éditions du|Laboureur, Jean Émile|Camuset, Georges 29928 French|French|French 103 1877 |1900 1943 |2000 1926 1926 1926   Overall: 9 1/16 x 6 11/16 x 1/2 in. (23 x 17 x 1.2 cm) Gift of Harold Bell, 1936                       Books 442   Metropolitan Museum of Art, New York, NY 1
436674 GV1801 .L6 1889 1 1 726717 The Libraries 20   Les jeux du cirque et la vie foraine           Publisher|Illustrator|Author 2650   E. Plon, Nourrit et Cie.|Jules Garnier|Hugues Le Roux French, 1847–1889   Plon E., Nourrit et Cie.|Garnier, Jules|Le Roux Hugues 55561   1847 1889 1889 1889 1889   v, 250 pages : illustrations(some color), color portraits ; Height: 11 13/16 in. (30 cm)     Paris 27     France 9                 Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 115.48ms · Data license: CC0 · Data source: metmuseum/openaccess